﻿CREATE TABLE [dbo].[EventData] (
    [EventID]        INT           IDENTITY (1, 1) NOT NULL,
    [CurrentReading] FLOAT         NOT NULL,
    [CurrentTemp]    FLOAT         NOT NULL,
    [EventTimeStamp] DATETIME      NOT NULL,
    [EventType]      NVARCHAR (10) NOT NULL,
    [MeterHeadEndID] NVARCHAR (50) NOT NULL,
    [MeterNumber]    NVARCHAR (50) NOT NULL,
    [MeterVendor]    NVARCHAR (50) NOT NULL
);

